{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Quick Start\n",
    "\n",
    "\n",
    "- 数据本身的基本统计分析\n",
    "- 研究问题本身，找到相关的强特征，建立一个简单的线性回归"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 读入数据\n",
    "\n",
    "\n",
    "- 训练数据 15000 persion, 136万条数据，770个负样本。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# 读入数据\n",
    "import pandas as pd\n",
    "dat = pd.read_csv('data/train.tsv', sep='\\t')\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1368146, 55)"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PERSONID</th>\n",
       "      <th>APPLYNO</th>\n",
       "      <th>FTR0</th>\n",
       "      <th>FTR1</th>\n",
       "      <th>FTR2</th>\n",
       "      <th>FTR3</th>\n",
       "      <th>FTR4</th>\n",
       "      <th>FTR5</th>\n",
       "      <th>FTR6</th>\n",
       "      <th>FTR7</th>\n",
       "      <th>...</th>\n",
       "      <th>FTR43</th>\n",
       "      <th>FTR44</th>\n",
       "      <th>FTR45</th>\n",
       "      <th>FTR46</th>\n",
       "      <th>FTR47</th>\n",
       "      <th>FTR48</th>\n",
       "      <th>FTR49</th>\n",
       "      <th>FTR50</th>\n",
       "      <th>FTR51</th>\n",
       "      <th>CREATETIME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>20fab21284e57a4ccd3127553920e37b</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000832</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001532</td>\n",
       "      <td>A2B186C398E0D0</td>\n",
       "      <td>2015-09-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>73f32b8b6e199129abb8fe0cb6d6c867</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007829</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002801</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.005156</td>\n",
       "      <td>A24B176C1239E0D0</td>\n",
       "      <td>2015-09-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>324da7a0b1a5c1d3b321685d734a9dc8</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C6E0D0</td>\n",
       "      <td>2015-09-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>341ceb4ae7b0ca1c46653f5a116d4bd2</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C6E0D0</td>\n",
       "      <td>2015-10-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>ca260c60e62de319e38a475e2455afb8</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007829</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002801</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.005156</td>\n",
       "      <td>A24B176C1239E0D0</td>\n",
       "      <td>2015-10-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>55eac334641dd47c43d5f95c5e2b6e6f</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000832</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001532</td>\n",
       "      <td>A2B186C398E0D0</td>\n",
       "      <td>2015-10-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>ce6cf113cde7df53b776dafb77049487</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C6E0D0</td>\n",
       "      <td>2015-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>f699af5bb8589446c7a1d06632b35f7b</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007829</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002801</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.005156</td>\n",
       "      <td>A24B3634C1239E0D0</td>\n",
       "      <td>2015-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>b55e5b0bd3817ffb897e1dcaf430f3ca</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000832</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001532</td>\n",
       "      <td>A2B287C398E0D0</td>\n",
       "      <td>2015-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>54d4bf98bd7baadd5306f41ab1e3af89</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007829</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002801</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.005156</td>\n",
       "      <td>A24B3634C1239E0D0</td>\n",
       "      <td>2015-12-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>ffe0ada115ee3648afc5962253509487</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C6E0D0</td>\n",
       "      <td>2015-12-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>a0220c17caac16cf8ae9e0f8c509f7b1</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000832</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001532</td>\n",
       "      <td>A2B287C398E0D0</td>\n",
       "      <td>2015-12-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>8071e5cafd17ea73eedf051dfc7cd05d</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000077</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E12D0,A0B0C9E0D0</td>\n",
       "      <td>2015-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>fa339fd5516febc32e1216bd1c962d77</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C428E0D0,A0B0C82E0D0,A0B0C465E0D0,A0B0C95E0D0</td>\n",
       "      <td>2015-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>be796062e280f63c9286646c259d6964</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.003914</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001400</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002578</td>\n",
       "      <td>A24B176C1239E0D0</td>\n",
       "      <td>2015-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>fd08a116609b2643e9e562228519ffc2</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001865</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003433</td>\n",
       "      <td>A2B186C782E0D0</td>\n",
       "      <td>2015-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>b56c8f0634d8f32f19d8070f11a2e634</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C428E0D0,A0B0C206E0D0,A0B0C75E0D0</td>\n",
       "      <td>2015-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>2968d3e3a77e2170b67a01743e50382b</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000023</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C6E0D0</td>\n",
       "      <td>2015-12-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>79878876f0994d39d8444a56a78c0133</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007829</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002801</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.005156</td>\n",
       "      <td>A24B3634C1239E0D0</td>\n",
       "      <td>2015-12-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>f41765a67ac2e00a5e091f56032283a2</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000832</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001532</td>\n",
       "      <td>A2B287C398E0D0</td>\n",
       "      <td>2015-12-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>762caa4db4f6b6332477a68aa2d19449</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C63E0D0,A0B0C505E766D24,A0B0C482E0D0,A0B0C...</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>84a8ce461fd35450351a7125c40216f5</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000774</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001425</td>\n",
       "      <td>A2B287C5534E0D0</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>7054ce347f3bfc0ccec9995dc619f558</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.007283</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002606</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.004797</td>\n",
       "      <td>A24B3634C6572E0D0</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>cbd885dcb39da7afe8b3592025b420e2</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000058</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C14E0D0</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>5e97f23aba0407cf297aa15ae4cea102</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000019</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C568E0D0,A0B0C11E0D0,A0B0C568E0D0</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>8bd181f5823768a8bf283b56afdebc10</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000449</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A2B400C369E0D0,A0B0C10E0D0,A52B1411C388E0D0,A2...</td>\n",
       "      <td>2015-09-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>76f58eee18edf59e9c14df1a261a8ce9</td>\n",
       "      <td>0.550000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-09-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>45a3f0dac549086cc347e66bed1b0c5a</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000769</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.699986</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C746E0D0,A0B74C917E0D0,A0B74C283E0D0,A0B7...</td>\n",
       "      <td>2015-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>08a207a612bed0199584387b2bd1c792</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C0E0D0,A0B0C10E5D3</td>\n",
       "      <td>2015-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>d48d52571a98a5c4e5e0251134718210</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-09-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>b50b6acaf31f96d9e28baeafefaf1fb1</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000769</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C319E0D0,A0B74C600E0D0,A0B74C1609E0D0,A0B...</td>\n",
       "      <td>2015-09-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>0b7b96a2cd2bf5c07af615ec6d9170b9</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000765</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C319E0D0,A0B74C600E0D0,A0B74C1609E0D0,A0B...</td>\n",
       "      <td>2015-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>6634603ff21c2fde6c0d4d9f7e493dce</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C0E0D0,A0B0C10E5D3</td>\n",
       "      <td>2015-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>342429107b36733b6469c7f003b1ca88</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000766</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C123E0D0,A0B74C280E0D0,A0B74C308E0D0,A0B7...</td>\n",
       "      <td>2015-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>7c6084101501b912c0e85d12b79aa97a</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C0E0D0,A0B0C10E5D3</td>\n",
       "      <td>2015-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>20c5ceb70851558795c037263a250425</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000775</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C1783E0D0,A0B74C354E0D0,A0B74C280E0D0,A0B...</td>\n",
       "      <td>2015-10-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>8d5c86defa8ce159d79ec78545874a5a</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-10-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>44b06087950e0e8c4d6c52268831e942</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000770</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C646E0D0,A0B74C319E0D0,A0B74C600E0D0,A0B7...</td>\n",
       "      <td>2015-10-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>dccfdfd11c06635a96c6f7c3c6f61813</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C0E0D0,A0B0C10E5D3</td>\n",
       "      <td>2015-10-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>4bdb93d2e66e882cc277d46c9e55d9ab</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>5495578681d3ff64144dc434c044a4eb</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000765</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C1783E0D0,A0B74C405E0D0,A0B74C123E0D0,A0B...</td>\n",
       "      <td>2015-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>65f07be09be4059839e4f0f1bfa7a73c</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C14E0D0,A0B126C65E0D0,A0B126C81E14D9</td>\n",
       "      <td>2015-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>90414a426f2666f99ae632aa0c79f29b</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>876c568ae77314094ae609e69f8dc540</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>6085d2a8d0188c6541e2d3a1abf1c7e2</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B126C81E14D9,A0B0C14E0D0</td>\n",
       "      <td>2015-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>67ceaa7b588fcb14841debce3822f9ee</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>45f482bd8f03d39a10f219881ce4c7fc</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000653</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C123E0D0,A0B74C405E0D0,A0B74C1416E0D0,A0B...</td>\n",
       "      <td>2015-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>f98eba73bb844ca4e00ce0d517a8981c</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B0C10E5D3,A0B0C0E0D0</td>\n",
       "      <td>2015-05-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>46330226f1bf187c038657bcf5922d5b</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000772</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>A0B74C562E0D0,A0B74C1783E0D0,A0B74C354E0D0,A0B...</td>\n",
       "      <td>2015-05-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>737f6cee33b47a3857b65186f5f6251e</td>\n",
       "      <td>2eda539a5e0d66ed5d4c7a5e90c81be8</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001008</td>\n",
       "      <td>0.000788</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.001008</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000721</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.050012</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000809</td>\n",
       "      <td>A19B110C159E0D0,A0B0C10E0D0,A40B0C269E0D0,A2B5...</td>\n",
       "      <td>2015-06-30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            PERSONID                           APPLYNO  \\\n",
       "0   8ba94305557a4ec72435a9eb78001350  20fab21284e57a4ccd3127553920e37b   \n",
       "1   8ba94305557a4ec72435a9eb78001350  73f32b8b6e199129abb8fe0cb6d6c867   \n",
       "2   8ba94305557a4ec72435a9eb78001350  324da7a0b1a5c1d3b321685d734a9dc8   \n",
       "3   8ba94305557a4ec72435a9eb78001350  341ceb4ae7b0ca1c46653f5a116d4bd2   \n",
       "4   8ba94305557a4ec72435a9eb78001350  ca260c60e62de319e38a475e2455afb8   \n",
       "5   8ba94305557a4ec72435a9eb78001350  55eac334641dd47c43d5f95c5e2b6e6f   \n",
       "6   8ba94305557a4ec72435a9eb78001350  ce6cf113cde7df53b776dafb77049487   \n",
       "7   8ba94305557a4ec72435a9eb78001350  f699af5bb8589446c7a1d06632b35f7b   \n",
       "8   8ba94305557a4ec72435a9eb78001350  b55e5b0bd3817ffb897e1dcaf430f3ca   \n",
       "9   8ba94305557a4ec72435a9eb78001350  54d4bf98bd7baadd5306f41ab1e3af89   \n",
       "10  8ba94305557a4ec72435a9eb78001350  ffe0ada115ee3648afc5962253509487   \n",
       "11  8ba94305557a4ec72435a9eb78001350  a0220c17caac16cf8ae9e0f8c509f7b1   \n",
       "12  8ba94305557a4ec72435a9eb78001350  8071e5cafd17ea73eedf051dfc7cd05d   \n",
       "13  8ba94305557a4ec72435a9eb78001350  fa339fd5516febc32e1216bd1c962d77   \n",
       "14  8ba94305557a4ec72435a9eb78001350  be796062e280f63c9286646c259d6964   \n",
       "15  8ba94305557a4ec72435a9eb78001350  fd08a116609b2643e9e562228519ffc2   \n",
       "16  8ba94305557a4ec72435a9eb78001350  b56c8f0634d8f32f19d8070f11a2e634   \n",
       "17  8ba94305557a4ec72435a9eb78001350  2968d3e3a77e2170b67a01743e50382b   \n",
       "18  8ba94305557a4ec72435a9eb78001350  79878876f0994d39d8444a56a78c0133   \n",
       "19  8ba94305557a4ec72435a9eb78001350  f41765a67ac2e00a5e091f56032283a2   \n",
       "20  8ba94305557a4ec72435a9eb78001350  762caa4db4f6b6332477a68aa2d19449   \n",
       "21  8ba94305557a4ec72435a9eb78001350  84a8ce461fd35450351a7125c40216f5   \n",
       "22  8ba94305557a4ec72435a9eb78001350  7054ce347f3bfc0ccec9995dc619f558   \n",
       "23  8ba94305557a4ec72435a9eb78001350  cbd885dcb39da7afe8b3592025b420e2   \n",
       "24  8ba94305557a4ec72435a9eb78001350  5e97f23aba0407cf297aa15ae4cea102   \n",
       "25  505d2a4db5dd353b775b5a30a731c02d  8bd181f5823768a8bf283b56afdebc10   \n",
       "26  505d2a4db5dd353b775b5a30a731c02d  76f58eee18edf59e9c14df1a261a8ce9   \n",
       "27  505d2a4db5dd353b775b5a30a731c02d  45a3f0dac549086cc347e66bed1b0c5a   \n",
       "28  505d2a4db5dd353b775b5a30a731c02d  08a207a612bed0199584387b2bd1c792   \n",
       "29  505d2a4db5dd353b775b5a30a731c02d  d48d52571a98a5c4e5e0251134718210   \n",
       "30  505d2a4db5dd353b775b5a30a731c02d  b50b6acaf31f96d9e28baeafefaf1fb1   \n",
       "31  505d2a4db5dd353b775b5a30a731c02d  0b7b96a2cd2bf5c07af615ec6d9170b9   \n",
       "32  505d2a4db5dd353b775b5a30a731c02d  6634603ff21c2fde6c0d4d9f7e493dce   \n",
       "33  505d2a4db5dd353b775b5a30a731c02d  342429107b36733b6469c7f003b1ca88   \n",
       "34  505d2a4db5dd353b775b5a30a731c02d  7c6084101501b912c0e85d12b79aa97a   \n",
       "35  505d2a4db5dd353b775b5a30a731c02d  20c5ceb70851558795c037263a250425   \n",
       "36  505d2a4db5dd353b775b5a30a731c02d  8d5c86defa8ce159d79ec78545874a5a   \n",
       "37  505d2a4db5dd353b775b5a30a731c02d  44b06087950e0e8c4d6c52268831e942   \n",
       "38  505d2a4db5dd353b775b5a30a731c02d  dccfdfd11c06635a96c6f7c3c6f61813   \n",
       "39  505d2a4db5dd353b775b5a30a731c02d  4bdb93d2e66e882cc277d46c9e55d9ab   \n",
       "40  505d2a4db5dd353b775b5a30a731c02d  5495578681d3ff64144dc434c044a4eb   \n",
       "41  505d2a4db5dd353b775b5a30a731c02d  65f07be09be4059839e4f0f1bfa7a73c   \n",
       "42  505d2a4db5dd353b775b5a30a731c02d  90414a426f2666f99ae632aa0c79f29b   \n",
       "43  505d2a4db5dd353b775b5a30a731c02d  876c568ae77314094ae609e69f8dc540   \n",
       "44  505d2a4db5dd353b775b5a30a731c02d  6085d2a8d0188c6541e2d3a1abf1c7e2   \n",
       "45  505d2a4db5dd353b775b5a30a731c02d  67ceaa7b588fcb14841debce3822f9ee   \n",
       "46  505d2a4db5dd353b775b5a30a731c02d  45f482bd8f03d39a10f219881ce4c7fc   \n",
       "47  505d2a4db5dd353b775b5a30a731c02d  f98eba73bb844ca4e00ce0d517a8981c   \n",
       "48  505d2a4db5dd353b775b5a30a731c02d  46330226f1bf187c038657bcf5922d5b   \n",
       "49  737f6cee33b47a3857b65186f5f6251e  2eda539a5e0d66ed5d4c7a5e90c81be8   \n",
       "\n",
       "        FTR0  FTR1  FTR2  FTR3      FTR4      FTR5  FTR6      FTR7  \\\n",
       "0   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "1   0.033333   0.0   0.0   0.0  0.000000  0.007829   0.0  0.000000   \n",
       "2   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "3   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "4   0.050000   0.0   0.0   0.0  0.000000  0.007829   0.0  0.000000   \n",
       "5   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "6   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "7   0.050000   0.0   0.0   0.0  0.000000  0.007829   0.0  0.000000   \n",
       "8   0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "9   0.050000   0.0   0.0   0.0  0.000000  0.007829   0.0  0.000000   \n",
       "10  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "11  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "12  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "13  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "14  0.050000   0.0   0.0   0.0  0.000000  0.003914   0.0  0.000000   \n",
       "15  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "16  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "17  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "18  0.050000   0.0   0.0   0.0  0.000000  0.007829   0.0  0.000000   \n",
       "19  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "20  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "21  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "22  0.050000   0.0   0.0   0.0  0.000000  0.007283   0.0  0.000000   \n",
       "23  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "24  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "25  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "26  0.550000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "27  0.033333   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "28  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "29  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "30  0.020000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "31  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "32  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "33  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "34  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "35  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "36  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "37  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "38  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "39  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "40  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "41  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "42  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "43  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "44  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "45  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "46  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "47  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "48  0.050000   0.0   0.0   0.0  0.000000  0.000000   0.0  0.000000   \n",
       "49  0.050000   0.0   0.0   0.0  0.001008  0.000788   0.0  0.001008   \n",
       "\n",
       "       ...         FTR43     FTR44  FTR45  FTR46     FTR47     FTR48  FTR49  \\\n",
       "0      ...      0.000832  0.050000    0.0    0.0  0.000000  0.050012    0.0   \n",
       "1      ...      0.002801  0.033333    0.0    0.0  0.000000  0.033333    0.0   \n",
       "2      ...      0.000000  0.050000    0.0    0.0  0.000023  0.050000    0.0   \n",
       "3      ...      0.000000  0.050000    0.0    0.0  0.000023  0.050000    0.0   \n",
       "4      ...      0.002801  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "5      ...      0.000832  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "6      ...      0.000000  0.050000    0.0    0.0  0.000023  0.050000    0.0   \n",
       "7      ...      0.002801  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "8      ...      0.000832  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "9      ...      0.002801  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "10     ...      0.000000  0.050000    0.0    0.0  0.000023  0.050000    0.0   \n",
       "11     ...      0.000832  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "12     ...      0.000000  0.050000    0.0    0.0  0.000077  0.050000    0.0   \n",
       "13     ...      0.000000  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "14     ...      0.001400  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "15     ...      0.001865  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "16     ...      0.000000  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "17     ...      0.000000  0.050000    0.0    0.0  0.000023  0.050000    0.0   \n",
       "18     ...      0.002801  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "19     ...      0.000832  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "20     ...      0.000000  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "21     ...      0.000774  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "22     ...      0.002606  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "23     ...      0.000000  0.050000    0.0    0.0  0.000058  0.050000    0.0   \n",
       "24     ...      0.000000  0.050000    0.0    0.0  0.000019  0.050000    0.0   \n",
       "25     ...      0.000449  0.050000    0.0    0.0  0.000000  0.050012    0.0   \n",
       "26     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "27     ...      0.000769  0.033333    0.0    0.0  0.000000  0.699986    0.0   \n",
       "28     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050012    0.0   \n",
       "29     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050012    0.0   \n",
       "30     ...      0.000769  0.020000    0.0    0.0  0.000000  0.020000    0.0   \n",
       "31     ...      0.000765  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "32     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "33     ...      0.000766  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "34     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "35     ...      0.000775  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "36     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "37     ...      0.000770  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "38     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "39     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "40     ...      0.000765  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "41     ...      0.000000  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "42     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "43     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "44     ...      0.000000  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "45     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "46     ...      0.000653  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "47     ...      0.000000  0.050000    0.0    0.0  0.000012  0.050000    0.0   \n",
       "48     ...      0.000772  0.050000    0.0    0.0  0.000000  0.050000    0.0   \n",
       "49     ...      0.000721  0.050000    0.0    0.0  0.000000  0.050012    0.0   \n",
       "\n",
       "       FTR50                                              FTR51  CREATETIME  \n",
       "0   0.001532                                     A2B186C398E0D0  2015-09-14  \n",
       "1   0.005156                                   A24B176C1239E0D0  2015-09-14  \n",
       "2   0.000000                                         A0B0C6E0D0  2015-09-14  \n",
       "3   0.000000                                         A0B0C6E0D0  2015-10-16  \n",
       "4   0.005156                                   A24B176C1239E0D0  2015-10-16  \n",
       "5   0.001532                                     A2B186C398E0D0  2015-10-16  \n",
       "6   0.000000                                         A0B0C6E0D0  2015-11-17  \n",
       "7   0.005156                                  A24B3634C1239E0D0  2015-11-17  \n",
       "8   0.001532                                     A2B287C398E0D0  2015-11-17  \n",
       "9   0.005156                                  A24B3634C1239E0D0  2015-12-08  \n",
       "10  0.000000                                         A0B0C6E0D0  2015-12-08  \n",
       "11  0.001532                                     A2B287C398E0D0  2015-12-08  \n",
       "12  0.000000                            A0B0C10E12D0,A0B0C9E0D0  2015-03-06  \n",
       "13  0.000000  A0B0C428E0D0,A0B0C82E0D0,A0B0C465E0D0,A0B0C95E0D0  2015-03-06  \n",
       "14  0.002578                                   A24B176C1239E0D0  2015-03-06  \n",
       "15  0.003433                                     A2B186C782E0D0  2015-03-06  \n",
       "16  0.000000              A0B0C428E0D0,A0B0C206E0D0,A0B0C75E0D0  2015-03-06  \n",
       "17  0.000000                                         A0B0C6E0D0  2015-12-05  \n",
       "18  0.005156                                  A24B3634C1239E0D0  2015-12-05  \n",
       "19  0.001532                                     A2B287C398E0D0  2015-12-05  \n",
       "20  0.000000  A0B0C63E0D0,A0B0C505E766D24,A0B0C482E0D0,A0B0C...  2016-02-16  \n",
       "21  0.001425                                    A2B287C5534E0D0  2016-02-16  \n",
       "22  0.004797                                  A24B3634C6572E0D0  2016-02-16  \n",
       "23  0.000000                                        A0B0C14E0D0  2016-02-16  \n",
       "24  0.000000              A0B0C568E0D0,A0B0C11E0D0,A0B0C568E0D0  2016-02-16  \n",
       "25  0.000000  A2B400C369E0D0,A0B0C10E0D0,A52B1411C388E0D0,A2...  2015-09-07  \n",
       "26  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-09-07  \n",
       "27  0.000000  A0B74C746E0D0,A0B74C917E0D0,A0B74C283E0D0,A0B7...  2015-09-08  \n",
       "28  0.000000                             A0B0C0E0D0,A0B0C10E5D3  2015-09-08  \n",
       "29  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-09-15  \n",
       "30  0.000000  A0B74C319E0D0,A0B74C600E0D0,A0B74C1609E0D0,A0B...  2015-09-15  \n",
       "31  0.000000  A0B74C319E0D0,A0B74C600E0D0,A0B74C1609E0D0,A0B...  2015-09-22  \n",
       "32  0.000000                             A0B0C0E0D0,A0B0C10E5D3  2015-09-22  \n",
       "33  0.000000  A0B74C123E0D0,A0B74C280E0D0,A0B74C308E0D0,A0B7...  2015-10-06  \n",
       "34  0.000000                             A0B0C0E0D0,A0B0C10E5D3  2015-10-06  \n",
       "35  0.000000  A0B74C1783E0D0,A0B74C354E0D0,A0B74C280E0D0,A0B...  2015-10-13  \n",
       "36  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-10-13  \n",
       "37  0.000000  A0B74C646E0D0,A0B74C319E0D0,A0B74C600E0D0,A0B7...  2015-10-20  \n",
       "38  0.000000                             A0B0C0E0D0,A0B0C10E5D3  2015-10-20  \n",
       "39  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-12-02  \n",
       "40  0.000000  A0B74C1783E0D0,A0B74C405E0D0,A0B74C123E0D0,A0B...  2015-12-02  \n",
       "41  0.000000           A0B0C14E0D0,A0B126C65E0D0,A0B126C81E14D9  2015-12-02  \n",
       "42  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-12-02  \n",
       "43  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-11-12  \n",
       "44  0.000000                         A0B126C81E14D9,A0B0C14E0D0  2015-11-12  \n",
       "45  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-11-17  \n",
       "46  0.000000  A0B74C123E0D0,A0B74C405E0D0,A0B74C1416E0D0,A0B...  2015-11-17  \n",
       "47  0.000000                             A0B0C10E5D3,A0B0C0E0D0  2015-05-02  \n",
       "48  0.000000  A0B74C562E0D0,A0B74C1783E0D0,A0B74C354E0D0,A0B...  2015-05-02  \n",
       "49  0.000809  A19B110C159E0D0,A0B0C10E0D0,A40B0C269E0D0,A2B5...  2015-06-30  \n",
       "\n",
       "[50 rows x 55 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "A0B0C6E0D0                                                                                                                                                                                                                                                                       55209\n",
       "A0B0C0E0D0                                                                                                                                                                                                                                                                       53933\n",
       "A0B0C10E5D3,A0B0C0E0D0                                                                                                                                                                                                                                                           31240\n",
       "A0B0C0E0D0,A0B0C10E5D3                                                                                                                                                                                                                                                           24964\n",
       "A0B0C14E0D0                                                                                                                                                                                                                                                                      18938\n",
       "A0B0C41E5D3,A0B0C0E0D0                                                                                                                                                                                                                                                           18689\n",
       "A0B0C0E0D0,A0B0C2E4D1                                                                                                                                                                                                                                                            15270\n",
       "A0B0C0E0D0,A0B0C41E5D3                                                                                                                                                                                                                                                           15075\n",
       "A0B0C11E0D0                                                                                                                                                                                                                                                                      13701\n",
       "A0B0C9E0D0                                                                                                                                                                                                                                                                       12963\n",
       "A0B0C2E4D1,A0B0C0E0D0                                                                                                                                                                                                                                                            11335\n",
       "A0B0C1E0D0                                                                                                                                                                                                                                                                       11244\n",
       "A7B25C10E5D3,A7B25C0E0D0                                                                                                                                                                                                                                                         10929\n",
       "A0B0C0E0D0,A0B0C2E1D1                                                                                                                                                                                                                                                            10249\n",
       "A0B0C6E0D0,A0B0C2E4D1                                                                                                                                                                                                                                                            10242\n",
       "A0B0C3E0D0                                                                                                                                                                                                                                                                        9598\n",
       "A0B0C7E0D0                                                                                                                                                                                                                                                                        9126\n",
       "A7B25C0E0D0,A7B25C10E5D3                                                                                                                                                                                                                                                          8916\n",
       "A0B0C8E0D0                                                                                                                                                                                                                                                                        8065\n",
       "A0B0C2E4D1,A0B0C6E0D0                                                                                                                                                                                                                                                             7815\n",
       "A0B0C2E1D1,A0B0C0E0D0                                                                                                                                                                                                                                                             7301\n",
       "A7B25C41E5D3,A7B25C0E0D0                                                                                                                                                                                                                                                          6733\n",
       "A0B0C10E5D3,A0B0C10E0D0                                                                                                                                                                                                                                                           5884\n",
       "A0B0C10E0D0                                                                                                                                                                                                                                                                       5822\n",
       "A0B0C6E0D0,A0B0C2E1D1                                                                                                                                                                                                                                                             5468\n",
       "A0B0C64E0D0                                                                                                                                                                                                                                                                       5390\n",
       "A7B25C0E0D0,A7B25C41E5D3                                                                                                                                                                                                                                                          5366\n",
       "A0B0C1E0D0,A0B0C2E1D1                                                                                                                                                                                                                                                             5147\n",
       "A7B25C0E0D0,A7B25C2E4D1                                                                                                                                                                                                                                                           4859\n",
       "A0B0C14E0D0,A0B0C2E1D1                                                                                                                                                                                                                                                            4797\n",
       "                                                                                                                                                                                                                                                                                 ...  \n",
       "A2B107C1632E0D0,A2B70C222E0D0,A2B154C78E0D0,A2B70C491E0D0,A19B314C5663E0D0                                                                                                                                                                                                           1\n",
       "A33B31C8004E0D0,A2B49C74E0D0,A2B113C184E0D0,A6B145C210E0D0,A18B52C235E0D0                                                                                                                                                                                                            1\n",
       "A2B108C3092E0D0,A2B48C1101E0D0,A1B65C376E0D0,A5B177C1164E0D0,A2B48C163E0D0                                                                                                                                                                                                           1\n",
       "A2B227C342E0D0,A3B17C29E0D0,A3B142C198E24D10,A1B542C1114E0D0,A2B529C955E0D0                                                                                                                                                                                                          1\n",
       "A0B0C80E0D0,A0B0C10E0D0,A0B0C568E0D0,A0B0C5E0D0,A0B0C50E0D0                                                                                                                                                                                                                          1\n",
       "A0B256C41E0D0,A1B33C191E0D0,A0B0C200E0D0,A0B0C81E80D9,A0B0C26E0D0,A0B0C63E0D0                                                                                                                                                                                                        1\n",
       "A2B1857C3350E0D0,A2B586C847E0D0,A2B582C840E0D0,A2B929C964E0D0,A2B1229C1020E0D0,A2B1230C2200E0D0,A0B0C77E0D0,A0B0C14E0D0,A0B0C2E0D0,A0B0C14E0D0,A0B0C50E0D0,A2B585C831E0D0                                                                                                            1\n",
       "A2B9C19E0D0,A2B261C188E0D0,A2B259C189E0D0,A24B283C400E34D17,A3B134C261E24D10                                                                                                                                                                                                         1\n",
       "A3B3550C261E24D10,A34B832C1742E0D0                                                                                                                                                                                                                                                   1\n",
       "A0B74C330E0D0,A0B74C655E0D0,A0B74C1263E0D0,A0B74C1193E0D0,A0B74C550E0D0,A0B74C690E0D0,A0B74C136E0D0,A0B74C3390E0D0,A0B74C573E0D0,A0B74C907E0D0,A0B74C819E0D0,A0B74C1481E0D0,A0B74C1224E0D0,A0B74C282E0D0,A0B74C279E0D0,A0B74C570E0D0,A0B74C1162E0D0                                  1\n",
       "A3B190C274E0D0,A47B74C653E0D0,A47B74C312E0D0,A47B74C36E0D0,A47B74C330E0D0,A47B74C213E0D0,A47B74C1041E0D0,A47B74C1112E0D0,A47B74C70E0D0,A47B74C279E0D0,A47B74C572E0D0,A47B74C136E0D0,A47B74C287E0D0,A47B74C292E0D0,A47B74C312E0D0,A47B74C126E0D0,A47B74C784E0D0,A47B74C303E0D0        1\n",
       "A1B335C447E0D0,A0B0C10E0D0,A20B92C158E0D0                                                                                                                                                                                                                                            1\n",
       "A12B74C1504E0D0,A12B74C225E0D0,A12B74C203E0D0,A12B74C1001E0D0,A12B74C1295E0D0,A12B74C204E0D0,A12B74C602E0D0,A12B74C126E0D0,A12B74C321E0D0,A12B74C213E0D0,A12B74C322E0D0,A12B74C829E0D0,A12B74C123E0D0                                                                                1\n",
       "A3B137C185E0D0,A2B212C2019E0D0,A4B636C5962E0D0                                                                                                                                                                                                                                       1\n",
       "A33B31C6658E0D0,A2B251C666E0D0,A18B52C2513E0D0,A6B145C120E0D0                                                                                                                                                                                                                        1\n",
       "A0B0C4E0D0,A0B0C2E0D0,A0B0C4E0D0,A0B0C4E0D0,A0B0C134E0D0,A0B0C14E0D0,A0B0C81E0D0,A1B110C62E0D0,A0B0C2E0D0,A0B0C6E171D0,A0B0C65E0D0,A0B0C26E0D0                                                                                                                                       1\n",
       "A0B126C4E0D0,A0B0C14E0D0,A0B4C2E0D0,A0B0C14E0D0,A0B126C65E0D0,A0B126C26E0D0,A0B256C67E0D0,A0B256C172E0D0,A0B4C14E0D0,A0B0C10E0D0,A0B126C67E0D0                                                                                                                                       1\n",
       "A0B303C432E0D0,A0B126C2E0D0,A0B126C26E0D0,A0B126C65E0D0                                                                                                                                                                                                                              1\n",
       "A47B74C1877E0D0,A47B74C34E0D0,A47B74C1898E0D0,A47B74C35E0D0,A47B74C793E0D0,A47B74C1372E0D0,A47B74C624E0D0,A47B74C205E0D0,A47B74C284E0D0                                                                                                                                              1\n",
       "A8B31C59E0D0,A28B168C1949E0D0,A2B160C236E104D14                                                                                                                                                                                                                                      1\n",
       "A2B584C844E0D0,A2B1750C265E0D0                                                                                                                                                                                                                                                       1\n",
       "A1B2882C4990E49D23,A1B102C5508E0D0,A50B0C170E0D0,A2B70C4542E0D0,A19B314C436E0D0,A5B32C5238E0D0,A1B96C3503E0D0                                                                                                                                                                        1\n",
       "A0B0C6333E0D0,A0B0C11E0D0,A0B0C50E0D0,A0B0C75E0D0,A0B0C1252E0D0,A0B0C3124E0D0,A0B0C2E0D0                                                                                                                                                                                             1\n",
       "A35B74C312E0D0,A35B74C224E0D0,A35B74C571E0D0,A35B74C835E0D0,A35B398C700E0D0,A35B74C309E0D0,A35B74C126E0D0,A35B74C290E0D0,A35B74C279E0D0,A35B74C302E0D0,A35B74C794E0D0,A35B74C562E0D0,A35B398C2284E0D0,A35B74C279E0D0                                                                 1\n",
       "A0B0C65E0D0,A13B3C10E0D0,A0B0C78E0D0,A0B0C1E0D0,A0B0C14E0D0,A0B0C14E0D0,A0B0C1E0D0                                                                                                                                                                                                   1\n",
       "A0B64C95E0D0,A0B74C780E0D0,A0B74C324E0D0,A0B74C279E0D0,A0B74C695E0D0,A0B74C565E0D0,A0B74C1056E0D0,A0B74C307E0D0,A0B74C162E0D0,A0B74C225E0D0,A0B74C1112E0D0                                                                                                                           1\n",
       "A0B0C67E0D0,A3B156C60E0D0,A3B190C274E0D0,A0B0C14E0D0                                                                                                                                                                                                                                 1\n",
       "A0B0C2E0D0,A0B0C4E0D0,A0B0C4E0D0,A0B0C4E0D0,A0B0C2E0D0,A0B0C2E0D0,A0B0C76E0D0                                                                                                                                                                                                        1\n",
       "A6B145C210E0D0,A1B81C159E0D0,A167B913C426E0D0                                                                                                                                                                                                                                        1\n",
       "A8B76C341E0D0,A1B119C323E0D0,A3B94C2111E0D0,A3B156C2166E0D0,A2B124C1516E0D0,A0B0C10E0D0,A0B570C3462E0D0                                                                                                                                                                              1\n",
       "Name: FTR51, Length: 332654, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat['FTR51'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#Length(unique(FTR51))/length(FTR) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dat_id = pd.read_csv('data/train_id.tsv', sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(15000, 2)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat_id.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PERSONID</th>\n",
       "      <th>LABEL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8ba94305557a4ec72435a9eb78001350</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>505d2a4db5dd353b775b5a30a731c02d</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>737f6cee33b47a3857b65186f5f6251e</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3933908961f8e1780ff0b87cc5e4401d</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>c15b755463ae71dd54fa4b39d95f5170</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           PERSONID  LABEL\n",
       "0  8ba94305557a4ec72435a9eb78001350      0\n",
       "1  505d2a4db5dd353b775b5a30a731c02d      0\n",
       "2  737f6cee33b47a3857b65186f5f6251e      0\n",
       "3  3933908961f8e1780ff0b87cc5e4401d      0\n",
       "4  c15b755463ae71dd54fa4b39d95f5170      0"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat_id.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "770"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(dat_id['LABEL'] == 1).sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## pandas 入门\n",
    "\n",
    "https://blog.csdn.net/zhu418766417/article/details/52718063"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    " s = pd.Series([1,3,5,np.nan,6,8])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1.0\n",
       "1    3.0\n",
       "2    5.0\n",
       "3    NaN\n",
       "4    6.0\n",
       "5    8.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def A(m,n):\n",
    "    r=1\n",
    "    while n>0:\n",
    "        r=m*r\n",
    "        m=m-1\n",
    "        n=n-1\n",
    "    return r \n",
    "           "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "720"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "A(10,3)                  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def C(m,n):\n",
    "    r=1\n",
    "    while n>0:\n",
    "        r=m*r/n\n",
    "        m=m-1\n",
    "        n=n-1\n",
    "    return r "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "120.0"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "C(10,3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  },
  "toc": {
   "base_numbering": 1.0,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
